Revealed: the friendliest and most attractive cities in the UK