My Best Friend the Hero Is Clinging to Me

(Gender swap + another world) Ling Yue got drunk and staggered down the road. A flash of light appeared in the distance, and when he woke up, he found himself somewhere unfamiliar. Was he still dreaming, or had he stumbled onto the wrong set? What? If I pull out the best sword in the village, I can't become a hero? What? I've become the Holy Knight of this land? What? My best buddy transmigrated too? And he became the hero! Looks like it's my turn to rise up. It's finally your turn to cling to my coattails, huh, buddy!