For Supabase I managed to update the auto-increment with the following syntax:
SELECT pg_catalog.setval('schema."tableName_fieldName_seq"'::regclass, 200, true);