Natural History Museum named UK’s most popular tourist attraction as it bucks trend