How to sort correctly?

Question

Django

There is a certain model (hundreds of thousands of records)
In the view we get a certain selection (a bunch of filters superimposed on each other) of the model (say, tens of thousands with pagination)
There is a user who displays instances of this model in the form of cards.
The user changes the order of displayed cards on his desktop. And keeps order.
Now, in any selection, if these cards fall into the selection, they should be displayed in the order in which the user placed them. If he put a certain card first, then when he gets into any sample, it should be given out first.
The question is how to organize the order of displaying cards for the user without dropping performance during the selection.

Answer 1

As an option

class CustomBullshit(Model):
   user = ForeignKey(User)
   bullshit = ForeignKey(Bullshit)