David Cameron has been recorded off camera complaining that people in Yorkshire hate everyone else and each other.