What might the business requirement have been to implement the final SELECT in this manner (using REVERSE, assuming it is parameterized from say @UserEnteredVIN)?
a) The Business requirement may be to store numeric values with Varchar data type. The column might possibly have leading zeros.
b) The Business requirement is that the VIN has to be distorted
So that unauthorized user will not easily decode the VIN