MAX(id) returns unexpected result

Content

Hello

I am having trouble with max(id) function returning value 9 instead of 522 even though the id column is of Integer Data type. 

----------------------------

select distinct Contact.CustomFields.c.accounttype.id from contact

ID
1
10
11
12
13
15
2
4
5
522
6
7
8
81
83
85
9

-------------------------

describe Contact.CustomFields.c.accounttype

Name	Type	Path
ID	Integer
Name	String
LookupName	String

select max(CustomFields.c.accounttype.id) from contact

max(CustomFields.c.accounttype.id)
9

 

Any recommendations? Thanks!