The 90s music icon had been enjoying a night out in Glasgow with friends when he took to the stage for an impromptu version of his famous hit, leaving pub-goers thrilled