Postgres >> manually alter sequence next value

SELECT setval('my_seq', 100, FALSE);
--my_seq >> your sequence name
-- 100 >> value you want to set
-- false >> means the next value would be 100
--       >> if it would be true then next value will be 100+1 = 101