Patrick Barkham: To my 17-year-old ears, this single was sunshine, hope and good times. But the only way was down for this band at the peak of their powers