Sexual abuse was rampant at a children’s home in the North run by a Catholic order of brothers, a former senior police officer has said.