One approach is to reverse the array and then take the first element of reversed array.

select(array_reverse(array_construct(0,1,2,3,4,5,6))[0]);  --returns 6