PS. I know that I am never going to do this again and I am going to join a non-drinking club in my school.
Your friend's parents might have a tough time, wanting their kids to go out with you again, especially if they believe you to be the key figure in getting everyone drunk. Given your recent track record in the "getting really drunk department," I'd say that you have your work cut out for you in earning back the trust and respect of your parents and your friends' parents. You also have your own self-respect to redeem.
You need to be more than a little scared that you and alcohol don't mix well together. In fact, I'd say that you need to stop drinking and get really clear-headed about the person you want to be. I would ask to speak to each of your friends' parents so that you can personally apologize to them and show genuine remorse for your irresponsible actions. You might also share with them how you plan on turning this behavior around.
Fortunately, neither you nor anyone else was injured or had to check into an emergency ward with alcohol poisoning. You have established a very unhealthy habit of drinking until drunk, let alone running the risk of being arrested for underage drinking. You might want to see a therapist for a few times so that you can get some understanding, support and advice on how best to turn this part of your life around.
Don't lose track of all your other good parts. These mistakes are not who you are but they are warnings that you have to act on. You are blessed with parents who will grant you their forgiveness and yet another chance for redemption. Embrace that chance and their belief in you. Understand what the circumstances, attitudes and reasons were that brought you to these poor decisions. Putting yourself in the same situations in the future and expecting that you will not drink is an unrealistic and dangerous assumption. Don't test yourself by doing something like this again. Rely on your judgment and don't put yourself in the same place, physically or mentally.
I believe that you have the courage and the character to take the high road. Thanks for writing.