You can get incremented ids using row_number() , and adding leading zeros to those integers using FORMAT() function :

In this query, I assumed you had a unique column called USERID , but you can order by any column you want.

UPDATE u
SET u.LOGIN = '5717-9889-' + FORMAT(s.rn, '0000' ) + '@xxxx.com',
    u.EMAIL = '5717-9889-' + FORMAT(s.rn, '0000' ) + '@xxxx.com'
FROM USERTEST u
INNER JOIN (
  SELECT LOGIN, row_number() over (order by USERID) AS rn
    FROM USERTEST
    WHERE LOGIN IN ('advw@12233318007262',
                    'caeqveewe',
                    'zxy@vdv',
                    'zstclair',
                    'zpasigna',
                    'zoe_tadvadv',
                    'zmadvadvadv',
                    'zadvadvadv',
                    'zielinsm@advadvadv.com',
                    'zhouxinhy',
                    'ZHEJIANG@BBAGGS',
                    'ZHE@avadvadv')
) as s on s.LOGIN = u.LOGIN

Demo here

You want to use the same order by in both locations, and cast the integer to varchar:

use a select to verify first:

WITH CTE AS (
  SELECT LOGIN, ROW_NUMBER() OVER (ORDER BY LOGIN) AS RowNumber
  FROM USERTEST
  WHERE LOGIN IN ('advw@12233318007262', 'caeqveewe', 'zxy@vdv', 'zstclair', 'zpasigna', 'zoe_tadvadv', 
                  'zmadvadvadv', 'zadvadvadv', 'zielinsm@advadvadv.com', 'zhouxinhy', 'ZHEJIANG@BBAGGS', 
                  'ZHE@avadvadv')
)
SELECT
      LOGIN = '5717-9889-' + RIGHT('000' + CAST(CTE.RowNumber AS VARCHAR(4)), 4) + '@xxxx.com'
    , EMAIL = '5717-9889-' + RIGHT('000' + CAST(CTE.RowNumber AS VARCHAR(4)), 4) + '@xxxx.com'
FROM USERTEST U
JOIN CTE ON U.LOGIN = CTE.LOGIN

If OK, then:

WITH CTE AS (
  SELECT LOGIN, ROW_NUMBER() OVER (ORDER BY LOGIN) AS RowNumber
  FROM USERTEST
  WHERE LOGIN IN ('advw@12233318007262', 'caeqveewe', 'zxy@vdv', 'zstclair', 'zpasigna', 'zoe_tadvadv', 
                  'zmadvadvadv', 'zadvadvadv', 'zielinsm@advadvadv.com', 'zhouxinhy', 'ZHEJIANG@BBAGGS', 
                  'ZHE@avadvadv')
)
UPDATE U
SET
     LOGIN = '5717-9889-' + RIGHT('000' + CAST(CTE.RowNumber AS VARCHAR(4)), 4) + '@xxxx.com'
   , EMAIL = '5717-9889-' + RIGHT('000' + CAST(CTE.RowNumber AS VARCHAR(4)), 4) + '@xxxx.com'
FROM USERTEST U
JOIN CTE ON U.LOGIN = CTE.LOGIN

fiddle