The green double-sided foam number plate tape from Halfords. The business part is black - it's the stuff you peel off and chuck away which is green, and it works because it's thick.
I was a bit dubious at first, but had no real choice other than double-sided tape of one kind or another after a fixing bolt sheared off flush in the rear plate holder of our last car.
The Halfords stuff held front and rear plates on the car for five years without any sign of loosening, and I've used it on the van too.
Buying something from Halfords that both works and doesn't cost a fortune is unusual.
.