UK cities were analysed and ranked an affordability score out of 10 to determine the most and least expensive places to live.