The great dichotomy of the Solar System: Small terrestrial embryos and massive giant planet cores