I have Safari synchonised between my Mac and iPad.
Fow weeks an iPad search for "far cry 6 pelicans" (I needed assistance finding pelicans in a videogame) has been listed in the cloud tabs, despite being closed weeks ago.
Wiping the Safari data on the iPad and resetting the cloud syncing didn't seem to affect anything. So instead I tried removing the tab directly on the Mac.
As with most macOS data, the Safari tabs live in an sqlite database somewhere under the users home directory.
Library/Safari/CloudTabs.db
has several tables, including cloud_tabs
with the following schema