SELECT

CAST(CASE
WHEN a = b
THEN i
ELSE i+1
END AS bit) as id

FROM mytable

SELECT a, b, sum(i) over(order by x) as id
  FROM (
    SELECT a, b, CASE WHEN a = b THEN 1 ELSE 0 END as i
      FROM mytable
  ) x