Glasgow turns rainbow as thousands celebrate Pride