Being a family pet is actually the most stressful job you can ask a dog to do. John Hearne talks to animal behaviourists in the wake of the recent fatal attack by a pack in Manchester