Edinburgh has been named as one of the top five most desirable places to live in the UK in a new study.