Ensuring ownership transfer during cross-query subset migration

[jdday]

• [ x ] I've validated the bug against the latest version of DB packages

Describe the bug
When an update would result in a row transferring between two live queries aimed at the same collection they reflect correctly optimistically but once refetch lands the row is corrupted and shows in the previous use live query collection instead of the target.

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.