Seven people, including two police officers, have died in a head-on collision in the north-east of England following a pursuit.