I studied in Aberdeen and they’re super LGBTQ+ friendly. They have their own club, and they regularly have events of all kinds.
Also, about 1/3 of the people i met were LGBTQ+. I can’t speak for other Unis, but I felt like Aberdeen was definitely very welcoming, open and supportive.