Use WPQuery to match to specific repeater row in post

WP_Query will get posts, the whole post. If another repeater field instance has data for LotNos the sort parameter will not understand what you mean.

What I’d do is getting all posts just by the date. Than I’d make a loop and create an array of objects with the data you need from each post (title, LotNo, image, etc). Than I’d use php usort function to sort the posts by the LotNo.

Finally I’d do a foreach() with this sorted object to print the data.