You can use SORT() to sort the array based on the key and then use LAST() to select the last object in the sorted array (the highest value)

SORT(example.data, "id") |> LAST(%)

​