How to determine if a column is the first part of an index?
Use INFORMATION_SCHEMA.KEY_COLUMN_USAGE to retrieve the position of columns in your key. The position of column in a key is the ORIDINAL_POSITION column of KEY_COLUMN_USAGE.

See more information from MySQL::The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table