How can I manage the order of products by using category wise instead of SKU name etc..?
You can do something like this, but without more information it's hard to determine exactly what you're asking.
Try creating a product attribute with the Default Label as Categories. In the Storefront Properties section set Use in Layered Navigation as Yes.
Then navigate to Catalog > Categories and select or create a category. In the Categories Display Settings, set Anchor as Yes.
That category should now be visible and filterable. A basic guide can be found here.