One car has been flipped on its side and a police car significantly damaged in a collision in a major city.