Filter by camera, and within those results, sort by file name.
As per the sorting that you would like to have for the ball approaching the bat, it wont be possible as Lightroom only reads the metadata of the image not the images.
However if you want to add multiple filtering options , you may go to the Filter bar in the Library Module, then select the Metadata option.
Once selected the Metadata you may select various filters that you want to add.
Please let us know if it helps.
You probably have two issues: 1) Camera clocks are not synchronized to the the second and 2) burst shots have the same time stamp.
To build on dj_paige's and trshaner's replies, I'd like to verify that your camera is or is not adding fractional seconds to the capture time. What make and model? Can you upload a sample pic to Dropbox or similar and post the link here?
In the past, I've seen circumstances where LR ignores fractional seconds that are stored in the metadata, and I'm trying to track down whether it's a LR bug.
To maintain the file sequence of bursts, and to properly sort images from multiple cameras by timestamp, I use a third-party program (Downloader Pro by BreezeSys.com) to transfer my images off the memory cards and rename them based on the capture timestamp in the EXIF data as "yyyymmdd_hhmmss_nnnn" where nnnn is the original file number. The original file number gets me the correct burst sequence and the full timestamp syncs the multiple cameras. For me, using two cameras within the same second will never happen. (After transferring the images to my hard drive, the file number in each camera is manually reset back to 1.)
Using this file naming, sorting by file name allows me to not worry about LR's use (or not use) of fractional seconds. Plus, I get the proper sorting in all the file browsers and image browsers.
Since I am doing lots of triage and sorting of photos up front, all my imports into LR are "add" not "copy".
rename them based on the capture timestamp in the EXIF data as "yyyymmdd_hhmmss_nnnn" where nnnn is the original file number.
You can do that renaming within LR as well, as described in this post in the thread that trshaner referenced: Sorting by Capture time, Image Burst out of sequence- - Lightroom Forums