Aberdeen in Scotland has been identified in a study as the most affordable city for single people looking to buy a home in Britain.