The UK notched two Top 5 cities in the ranking, which was compiled from a survey of more than 24,000 city dwellers