The 1990s singer was belting out his chart-topping hit in a Glasgow pub before the crowd realised who he was