Is the upgrade offer transferable to other passengers?

No, the upgrade offer is non-transferable. It is applicable to all passengers in the booking reference, indicated in the email announcing the offer.