Scotland’s most and least affordable cities revealed