What class would be good for a magician/trickster character?

I’m relatively new to DND-5e and want to make a magician/trickster character. I’d prefer this character to rely mostly on illusions, slight of hand, and trickery rather than pure magic. My DM recommended playing a Bard (college of glamour) or a Rogue (arcane trickster).

Thoughts?