If your new phone supports eSIM then simply delete the profile from the other device and scan your QR code on My Account with the new phone. That’s it, you’re all set.
If the phone you’re switching to doesn’t support eSIM then you’ll need to call 789 and request a regular SIM card. When this arrives, don’t forget to delete your eSIM.