Get ordinality of a row in an ordered result set
===

I have a collection of manifest records stored in a MySQL database.  The schema is as follows: 


    CREATE TABLE `manifests` (
    	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    	`carrier_id` INT(10) UNSIGNED NOT NULL COMMENT 'The carrier for which this manifest is being made',
    	`opened` DATETIME NOT NULL COMMENT 'Time the manifest was created',
    	`closed` DATETIME NULL DEFAULT NULL COMMENT 'Time the manifest was picked up and closed',
    	PRIMARY KEY (`id`),
    	INDEX `manifests_to_carriers_id` (`carrier_id`),
    	CONSTRAINT `manifests_to_carriers_id` FOREIGN KEY (`carrier_id`) REFERENCES `carriers` (`id`)
    )
    COMMENT='List of manifests that have been created by the system'
    COLLATE='utf8_general_ci'
    ENGINE=InnoDB;

During the day there may be several manifests closed and dispatched.  I can easily get all the manifests for a particular day, in the order they were dispatched.  For example I can get all the manifests that were dispatched today like this.  

    select * 
    from manifests 
    where date(closed) = date(now())
    order by closed

This will produce data like this: 

    "id"	"carrier_id"	"opened"	"closed"
    "4"	"1"	"2012-07-24 11:10:06"	"2012-07-24 11:10:32"
    "5"	"1"	"2012-07-24 11:10:40"	"2012-07-24 11:11:08"
    "6"	"1"	"2012-07-24 11:11:17"	"2012-07-24 11:11:59"

The carrier needs a sequence number to be included in the data we send them as well.  The first one sent on a particular day should be 1, the second one 2 and so on.  In this case record 4 would need a sequence number of 1, record 5 would need a number of 2, record 6 would need a sequence number of 3 and so on.  

When I pull a manifest for transmission I just select it by ID

    select * from manifests where id = 5

Is it possible to get MySQL to compute the ordinality of the above record and include it in the result as well?  Basically I think what I need is a count of the number of records that were created at an earlier time then the record of interest, but which were also created on the same day.  Is there an aggregate function that could do this, or is there some other trick I can use to achieve this with MySQL?
