High-sensitivity magnetometry with a single atom in a superposition of two circular Rydberg states