Your EUR SEPA IBAN should be used if you want to get paid in EUR. Tide will then convert the EUR funds and credit your primary GBP account.
Your GBP IBAN should be used if you want to get paid in GBP from overseas. These payments are usually sent to you via the SWIFT network.