The past year has seen a deterioration in affordability in UK cities, driven by rising house prices across the country