When you apply for a new card the first thing you get is this email. As you can see all the card details are in the app and it can be used online immediately. When the card is received the only activation needed is for contactless payments, by making a single chip and PIN payment, but as you can add the new card details to Google pay, etc. before you get it that is hardly much of an issue.