If you're selecting from another table, you don't need the VALUES keyword, you can just INSERT INTO \ SELECT FROM as follows...
INSERT INTO XYZ (SEQID, COMPANYID, BRANCHID, COUNT)
SELECT 111,1,[BRANCHID],COUNT(*)
FROM [TRN_ADVISOR]
GROUP BY [BRANCHID]