Your SIM card will be activated once it has been inserted in your phone and connected to the cellular network. The process is automatic, no action is required from you.
Regarding the eSIM version, Orange Holiday will be active once the QR code has been scanned and the phone connected to the cellular network. The process is automatic, no action is required from you.