Edinburgh and Birmingham are among the 54% of areas where pay has outpaced property prices since 2007.