What buys a five-bed house in Scotland may only get you a studio flat in parts of London, analysis reveals