Music has been the driving force of the legendary Scottish author’s career. At 66, he’s releasing a new Trainspotting sequel — and his debut album