Harnessing the relativistic Buneman instability for laser-ion acceleration in the transparency regime