This is simply not true. You're not talking about the same type of card. Tell me one website that doesn't allow Revolut one-time virtual cards (note that these are not prepaid cards)
I have Revolut and have encountered this a number of times.
The flow is usually that the merchant runs a check against the card by doing a £0 transaction rather than the correct card active check which resets the card number and causes the second transaction of the correct amount to fail.
The flow is usually that the merchant runs a check against the card by doing a £0 transaction rather than the correct card active check which resets the card number and causes the second transaction of the correct amount to fail.