It was “truly miraculous” that no one was killed in a 100-car pile-up on a bridge in the UK in heavy fog, police have said.