Trying to get cute with component designators will be more trouble than it's worth. Ultimately it comes down to the basic problem that component usage is multi-dimensional and no linear naming scheme is going describe that well.
Sometimes I've seen people use 3 digit designators with the first digit identifying the schematic sheet. That's only one parameter, and doesn't help at all for finding the component on the board. It's also a hassle to maintain as you move components between sheets.
Even worse, very rarely I've seen people try to use numbering to identify which subcircuit something belongs to. For example, R1xx might be for the power supply, R2xx with the microcontroller, etc. This is even harder to maintain than the page scheme and less useful. OK, so R105 is probably part of the power supply. Now what? That gives me a rough idea of one of the many dimensions but does nothing for the others. Then there will be a large number of in-between cases where are part could be thought of as belonging to two or more subcircuits. This becomes a mess quickly and takes more effort and attention to maintain than it ever saves. Forgettaboutit, keep it simple.
As for trying to number them by value, that makes even less sense. That's what the BOM is for anyway. Having sequential numbers for each BOM line doesn't solve any problem I have ever encountered.
Let your software pick whatever numbers it wants to initially. As you edit the schematic, there may be gaps and things move around. Don't worry about it. When the schematic is all done or you're going to export it for others to look at, you can run a renumber utility if your software has that. That usually starts the numbering for each component type at 1 and goes up sequentially. They will probably be in some rough order by placement on the schematic, but don't count on that. Once you realize that component designator numbers are arbitrary labels, life becomes simpler.
No scheme is going to give you much information about part usage just from the number, so you need to make a cross reference listing anyway. I use Eagle and have created the INDEX ULP for that purpose. It makes a alphabetic list of all component designators and gives their schematic and board coordinates.