“I gave away all my records, I started giving away my guitars, I was fantasising about my own death.” The horrifying origin story behind one of the most uplifting rock songs of the ’90s