Birmingham residents are almost as proud of city’s orchestra as its football clubs, study finds