Let me preface this by saying it's easy to give tough advice to strangers on Reddit. What follows is severe but worth considering.

The best apology here is going to AA. Because this is a massive warning sign right here. Booze:

-Caused you to do things you didn't want to do

-Caused you to harm someone (emotionally, but still)

-Made life difficult for the people close to you

Seriously, you need to never drink again if you want friends you can keep. Because your friends might stand by sober you if they know that drunk you is never gonna turn up again.