Armed cops descended on a quiet suburb in Middleton after the horror knife attack