Nationwide has revealed the most and least affordable regions for house prices in Britain.