Two children have been killed and nine more injured during a stabbing attack in England’s north-west that one witness likens to a “horror movie”.