Do category ID and product ID in catalogue bulk import CSV need to be filled by us?

No. The category ID and product ID need not be filled by the client, it is generated in the backend once the catalog is uploaded.