Alright.
Think of the 1000s of shy guys on this forum (like me) who have immensely improved their confidence - true confidence - to levels I would say substantially higher (in most aspects) than that of the normal guy.
Think of how many of those shy guys started off in your position - or even worse. Trust me, a lot of us had real xenophobic issues!
Now. If we can do it - why can't you?
It's possible mate. SO possible if you work at it. ANYONE is capable and guaranteed confidence with practice...I really believe that.
Just work at it pal
Don't use drugs to do that. You can literally be as sexually confident as you were that night permanently with practice. Imagine that! That will actually BE you in the future, and not the drugs.
That confidence will overlap in other areas of your life too, and help you with things like friendships, work, getting certain "special SPAM" randomly for being likeable
(eg yesterday I spoke to this hot female DJ just to ask her stuff about DJing as I was curious, and having the confidence to do that allowed me to DJ WITH her for a minute cos she thought I was a cool guy

As in, right during her set in front of a hundreds of people she was letting me "scratch" the electronic decks and play with fading effects!)
So yeah - do it properly and the payoffs will be immense and permanent.
As Confucius said,
"Give a man a fish and he will eat for a day. Teach a man to fish, and he will eat for his entire life"
This translates perfectly. Except you wont be fishing for fish, you will be grabbing women. And what you will be eating will be a HB10...
Enjoy life