A senior police detective has described the incident as “one of the most abhorrent acts committed during a break and enter” that he had seen in his career.