Affordability pressures weigh on capital while Manchester, Liverpool and other regional hubs benefit from population growth