On the Surprising Robustness of Sequential Convex Optimization for Contact-Implicit Motion Planning