Arriving in cinemas 20 years ago, Danny Boyle’s Trainspotting was a pop-cultural event and the defining British film of its era. Were we right to get so excited?