Heroin addiction and musical theatre are uneasy bedfellows in this Irvine Welsh adaptation at London’s Theatre Royal Haymarket