Trainspotting author Irvine Welsh likens former first minister to a ‘social engineer’ and says she picked the wrong issue to unite Scotland