The analysis by Rightmove was released as Halifax identified the UK’s most and least affordable locations to buy a home.