The story
From cake (here, buttocks) + topper, likening the tattoo to a decoration placed above the “cake”.
Etymology from Wiktionary, CC BY-SA 4.0.
cake topper
Today it means: A tattoo on the lower back, especially one centered immediately above the buttocks; a tramp stamp. Full definition →