London, Birmingham and Newcastle residents are the most ‘house proud’ in Britain, study finds