Asteroid impacts on terrestrial planets: The effects of super-Earths and the role of the ν6 resonance