Cambridge, Edinburgh and London have been named the top three cities for retirees but people retiring in these cities face substantial pension shortfalls and high property prices.