更新sql中的字段每次递增1

I am trying to construct an SQL query that would take a set of rows and renumber a field on all rows, starting at where they all match a session ID.I am trying to construct an SQL query that woul