You can change the image sequence only in collections without smart filtering.
To create a specific sequence of approved images, copy all approved images to a new collection. Then modify the sequence in the new collection.