The orders collection in store is admin read only, so we cannot read the data from orders collection directly in the published site, only in preview site.
Is there any other way to read the data from orders collection in published site?
There is no way to change the permissions also.
I want to query the specific row based on specific value,
please help on how to do it in any other way
Look at the Wix Stores with Corvid section of Wix Support and read up about the Wix Stores datasets that get added automatically when you add the Wix Stores app to your site.
https://support.wix.com/en/corvid-by-wix/wix-stores-with-corvid
You can’t change the any of the three collections from Wix Stores, however you can query it like it states in the support pages, you just have to add your own query functions to it, providing that the filter function that you want to use is useable with that dataset field.