‘Stark’ divergence between UK capital and rest of country comes as affordability pressures weigh on buyers