Observation of charmonium sequential suppression in heavy-ion collisions at the Relativistic Heavy Ion Collider