Select rows after a specific ID
You could do something like this with row_number(). Performance probably is going to depend on how many active articles are present each day.

This codes creates a seq based on the sort you provide and then finds the sequence of the last Id value, which you can use to grab the top (x) rows.

declare @LastId INT,
        @PageSize INT

set @LastId = 187322
set @PageSize = 2

;with cte
as(
SELECT *, seq = ROW_NUMBER() over(ORDER BY important DESC, release_date DESC, edit_date DESC)
FROM @demo d
WHERE 
    status = 1
    AND release_date &lt;= GETUTCDATE()
)
select TOP (@PageSize) *
from cte t1
where t1.seq &gt; (select seq from cte t2 where id = @LastId)
Order by t1.seq