Magma sorceries are amongst those hidden spell training in Elden Ring
On the north side, you will see the street main to the cave wherein the Amber Starlight is hidden. Subsequently, all you need to do is provide it to Seluvis to get the Magic Scorpion appeal in Elden Ring.
