Hyperedge overlap drives explosive transitions in systems with higher-order interactions