I’ve had what sounds like the same problem. I use Roon ROCK which pulls files in from a NAS and from Tidal. The only album I’ve seen with this problem has been imported from the NAS.
Looking in detail, the track numbers do not match the track title. So selecting the fourth track in Roon plays the fourth track on the album as listed on the NAS, it’s just that this is not the track Roon says it is. Sonos displays the track listing correctly so this is a problem with Roon metadata.
I seem to have fixed the problem by selecting Edit>Metadata and then scrolling down to the section labelled ‘Set Preference for the tracks of one album’. I then selected ‘Prefer File’ for ‘Track’s Title’, ‘Track’s Media Number’ and ‘Track’s Track Number’. Then hit save and the track listing is corrected.
I’ve only noticed the problem with this one album. This isn’t a solution if there are multiple albums with the problem. And doesn’t fix what seems to be an underlying issue with Roon.
Hope this helps.